Prepare for and practice interview questions from Mindlance.

Mindlance Interview Questions

Mindlance Interview Guides

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.

How would you assess the validity of the result?

Experiment Validity

In an A/B test, how can you check if assignment to the various buckets was truly random?

In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?

In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?

Random Bucketing

Mindlance Salaries by Position

Immediate Hire | Senior Risk Analyst - Issue Management | Tampa, FL (Hybrid) | Apply Now! Job Title: Senior Risk Analyst - Issue ManagementDuration: 06 Months (Possible Extension/Conversion)Location: Tampa, FL (Hybrid)Pay Range: $50 - $55/hr on w2 The bank is looking for a Business Risk Officer/Issues Management support Analyst who will be responsible for designing, developing, delivering and maintaining best-in-class Compliance Issues Management programs, policies and practices. Responsibilities:<ul><li>Designing, developing, delivering and maintaining best-in-class Compliance Issues Management programs, policies and practices for ICRM. </li><li>Work with Management on governance and the facilitation of the execution of the ICRM Issues Management Program.</li><li>Accountable for the quality, completeness, and accuracy of the implementation of the Global Issues Management Policy, Standard, Procedure, along with the ICRM Issues Management Procedure and other internal processes.</li><li>Conduct deep dives and analysis across the issues management space</li><li>Ensure the identification of issue root cause, partnering with control and process owners to recommend holistic corrective actions and improvements, provide check and challenge to ensure appropriate escalation in according with Issue Management and Escalation Policies.</li><li>Support management in the review and challenge process, within the FLUs, on the effective design and management of controls to mitigate risks as required by the Control Standards, including implementation and operation, conducting the control monitoring, handling deficiencies, and escalating issues for resolution. </li><li>Responsible that adequate governance and training are in place to support the Issues Management program.</li><li>Take ownership to ensure that issues management responsibilities and accountabilities are embedded within each area across ICRM, including providing training and leading by example.</li></ul> Qualifications:<ul><li>7+ years of experience with advanced knowledge of Issues Management</li><li>Consistently demonstrates clear and concise written and verbal communication skills</li><li>Expertise of Compliance laws, rules, regulations, risks and typologies;</li><li>Excellent written, verbal and analytical skills</li><li>Must be a self-starter, flexible, innovative and adaptive;</li><li>Highly motivated, strong attention to detail, team oriented, organized</li><li>Strong presentation skills with the ability to articulate complex problems and solutions through concise and clear messaging</li></ul> Education:<ul><li>Bachelor's/University degree, Master's degree preferred.</li></ul> “Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of – Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.”

Need data engineers with a software engineering background, not a DA or a BA that moved into data engineering. Need to be able to use all of those skills from software engineering as well as data analysis and data engineering to be able to work on AI tools. SKILLS - Python (9-10/10), SQL, and AWS BACKGROUND REQUIREMENTS - doesn't need to be previous cap one but it wouldn't hurt, software engineering background (true, heads down, coding), data analysis/data engineering experience after the software engineering experience.

Position: Business Analyst Location: Chicago, IL 60606 - Remote in Illinois Duration: 12 months Job Description: Project Name: Technology Lifecycle Management Top 5 Skill sets: 1. Analytical skills, Data collection, cleaning and analyzing data to identify trends, and potential issues 2.Stakeholder management and communication 3. Develops and maintains BI dashboards and reports 4. Understanding Power BI 5 Requirements gathering and project management support (assisting with project planning, tracking progress, and managing risks Nice to have skills or certifications: 1. Excel and PowerPoint 2.Problem solving skills 3.Presentation skills Preferred Hours of work: 8a.m.- 4pm- or 9am-5pm Work Location: Chicago, remote but if in IL will need to come in for meetings. Work Schedule: Remote if out of state. If in state, then will need to come in when requested for meetings or working sessions Will this person have to travel? No Interview Process:<ul> <li>Who is involved in the interview? Me, team member and possible a director</li> <li>Interview will be by Video with 1-2 interviews possible. </li></ul>Contract to Hire:<ul> <li>Possibility but not guaranteed. </li></ul> Job Summary: Drive identification of requirements across business units and identify substandard systems processes through evaluation of real-time data. Serve as thought leader for technical business processes, developing forward-thinking systems prototypes that promote increased efficiency and productivity on multiple levels Primary Responsibilities:<ul> <li>Create and implement precise management plans for every project, with attention to transparent communication at all levels.</li> <li>Perform, evaluate, and communicate thorough quality assurance at every stage of systems development.</li> <li>Determine and develop user requirements for systems in production, to ensure maximum usability.</li> <li>Partner with other stakeholder teams across business units (i.e., sales, finance, security, compliance) to develop necessary analysis and documentation in a collaborative way, communicating effectively and efficiently with production, managerial, and executive teams.</li> <li>Evaluate, analyze, and communicate systems requirements on a continuing basis, and maintain systems processes, including the delivery of monthly status reports to all appropriate parties.</li> <li>Author and update internal and external documentation, and formally initiate and deliver requirements and documentation.</li> <li>Conduct daily systems analytics to maximize effectiveness and troubleshoot problems.</li> <li>Develop meaningful and lasting relationships with partners for optimized systems integration, and respond to questions and concerns from managers and executives with supporting research and recommendations. </li></ul>Qualifications:<ul> <li>Technical Degree or related work experience.</li> <li>Proven experience in an analytics and systems development capacity.</li> <li>High proficiency with SQL language and database management.</li> <li>Proven analytical abilities.</li> <li>Practical experience generating process documentation and reports.</li> <li>Excellent communicator with the ability to translate data into actionable insights.</li> <li>Experience working with Business Objects. </li></ul>Knowledge of ITIL Foundations. EEO: "Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of - Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans."

Title: Senior Data Engineer - Pentaho Duration: 6 Months - Long Term Location: Washington, DC 20005 Hybrid Onsite: 2/3 days onsite per week from Day1. Candidate should be comfortable to pick official laptop from client location (Washington, DC 20005) after the onboarding process once offered. Summary/Objective: The Senior Data Engineer will execute on implementing business intelligence solutions across all divisions of the organization . The individual in this role will guide the team in design and implementation of each solution and will implement improvements of technical standards, development processes, governance, and technologies. Essential Duties And Responsibilities: <ul> <li>Serve as a technical lead in the development of business intelligence solutions . </li> <li>Coordinate with scrum masters / project managers on optimizing scheduling, work allocations, and story assignments. </li> <li>Manage reporting environment including data sources, connections, security, subscriptions and metadata. </li> <li>Assist in initiative towards data access control and integrity across the enterprise. </li> <li>Create data models and schema for reliable and highly performant data marts and data warehouse. </li> <li>Develops complex ETL (extract, transform and load) SQL scripts to gather data from various databases and systems to make data available for enterprise analytics and reporting. </li> <li>Evaluate, test and implement new or upgraded software. </li> <li>Troubleshoot reported problems pertaining to reports and the reporting database environment, working closely with other IT members, especially DBAs, Systems Analysts and Systems Engineers, </li> <li>identifying the cause and designing or developing an approach for resolution. </li> <li>Assess impact of changes and updates to source production systems, planning and implementing resulting changes to reports. </li> <li>Identify areas for improvement within the EDS organization related to architecture, design, performance optimization, development process, workflows, governance, tools/technologies. </li> <li>Conduct end user training on data solutions. </li> </ul> Education, Experience And Skills: <ul> <li>Bachelor Degree and/or relevant technical training with no preferred certification. </li> <li>Over 8-10 years of experience in the field of Information Technology with proficiency in ETL design/development and Data Warehouse Implementation/development. </li> <li>Experienced in Design, Development and Implementation of large - scale projects in Financial, Shipping and Retail industries using Data Warehousing ETL tools (Pentaho). </li> <li>Knowledge about Software Development Lifecycle (SDLC), Agile, CI/CD deployment. </li> <li>Experience in Architecting and building Data Warehouse systems and Business Intelligence systems including ETL using Pentaho BI Suite (Pentaho Data Integration Designer / Kettle). </li> <li>Hands on experience on the whole ETL (Extract Transformation & Load) process. </li> <li>Experience in creating ETL transformations and jobs using Pentaho Kettle Spoon designer and Pentaho Data Integration Designer and scheduling. </li> <li>Used various steps in Pentaho transformations including Row Normalizer, Row Demoralizer, Database Lookup, Database Join, Calculator, Add Sequence, Add Constants and various types of </li> <li>inputs and outputs for various data sources including Tables, Access, Text File, Excel and CSV file. </li> <li>Integrating Kettle (ETL) with Hadoop and other various NoSQL data and loaded unstructured data into Hadoop File System (HDFS). </li> <li>Experience in performing Data Masking/Protection using Pentaho Data Integration (Kettle) Strong development experience in writing PL/SQL Stored Procedures, Functions, packages and </li></ul> debugging the code <ul> <li>Strong development experience working with Columnar DBs preferably Client Vertica. </li> <li>Strong expertise in Developing and Debugging MSSQL or PostgreSQL SQL scripts, functions, stored procedures, views, complex SQL queries, cursors, and triggers </li> <li>Expertise in Performance tuning, Query optimization and exception handling </li> </ul>

Job Description: In this contingent resource assignment, you may: Consult as an expert to develop or influence initiatives and resources for highly complex business and technical needs across Engineering. Consult on the strategy and resolution of highly complex and unique challenges requiring in-depth evaluation across multiple areas, delivering solutions that are long-term, large-scale and require vision, creativity, innovation, and advanced analytical and inductive thinking. Provide expertise to client senior leadership on innovative Engineering business solutions. Strategically engage with client personnel. Required Qualifications: 7+ years of Engineering experience, or equivalent demonstrated through one or a combination of the following: work or consulting experience, training, military experience, education. We are seeking a contractor for the role of a Principal Customer Due Diligence (CDD) Engineer within Financial Crimes Technology, a unit of Enterprise Functions Technology (EFT). The person in this position will work with the Product, Architecture, and engineering teams to drive the design and implementation of new and enhanced capabilities that ensure successful delivery against critical commitments. The individual work with analysts to understand requirements, produce architectural artifacts, detail designs and work with engineers to drive implementation. In addition to CDD, this individual will need to understand the Fin Crimes landscape to ensure the proposed solutions align with the overall strategic vision of the Fin Crime domain. Candidates should offer most of the following: Bachelor's or Master's degree in computer science, engineering, or a related field Subject matter expertise in Financial Crimes, Customer Due Diligence, Corporate Risk, and our Compliance. Substantial experience working with data and data technology, particularly Customer data. Demonstrated experience in Agile development, application design, software development, and testing Proven experience in software development, with a focus on Cloud applications Hands-on experience in Kafka, Microservices, APIs, Analytics, Batch and Realtime Data processing. Experience with one or more CI/CD and Automation tools: Jenkins, GitHub Actions, Gradle, Maven, MSBuild, NPM, SonarQube, Artifactory, Harness CD & GitOps, IBM uDeploy, Ansible Understanding one or more of the following tools and technologies: PowerBI, Tableau,SQL Server, Oracle, Mongo DB, SQL server. Working experience in designing, architecting applications for deployment into one or more cloud (GCP, Azure, PCF/Tanzu) environments Strong analytical skills with high attention to detail and accuracy Strong technical skills and acumen. Knowledge of modern architectural paradigms, including service-orientation and cloud enablement. Excellent leadership and communication skills, with the ability to collaborate effectively across teams and mentor junior engineers. Strong interpersonal skills, including the ability to function well in a large, matrixed organization. Comments for Suppliers (Use this area to provide any additional comments to all suppliers. For example, any specific skills to prioritize when looking for profiles.: PART OF PILOT PROGRAM Title: Engineer 5/Transformation # of Positions: 2 Line of Business: EFT Risk & Internal Audit *PILOT/VMO* Manager: Man Yen Chin Location: New York City, NY (150 E 42nd St) Iselin, NJ (max bill rate ***) Charlotte, NC (max bill rate ***) dditional Notes: Net new Contract - 24 months, possibility to convert (if opportunity presents) RTO schedule - 3 days in office MANDATORY Interview process: 2 step virtual interviews: 1 with virtual interview with supervisor 1 with senior technical team member Supplier Expectations: All resumes must be submitted in beeline or will not be reviewed No soliciting of resumes, nor communication should occur with the Reports to Manager while position is live EEO: "Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of - Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans."

POSITION OVERVIEW: Senior Data Architec The client is seeking a Senior Cloud Data Architect to play a crucial role in Data platform architecture design and implementation. The Data Office will be supporting Department of Public Health (DPH) in the implementation of a Local Public Health Data Platform. This platform will serve as a key operational and reporting interface for the 351 local and regional boards of health in Massachusetts, housing key workflows, such as inspections and permitting; collecting pertinent data from local boards of health; and allowing reporting out to local boards of health using data held by the Department of Public Health, such as immunization rates and other key public health information. Utilizing a combination of Salesforce, Mulesoft, Snowflake, Informatica(IICS), and Tableau, the new local public health data platform will represent a major transformation in how information flows between the state and municipal governments. The ideal candidate is an expert in Design and implementation of Cloud Data platforms. You can clearly articulate and present different data architecture principles and standards. In this role, you are comfortable speaking to both business and technical stakeholders to ensure combined understanding and collaborative solutions. This role will be expected to own tasks and follow-up related to cloud data platform Design and development activities and establish well documented best practices and processes. DETAILED LIST OF JOB DUTIES AND RESPONSIBILITIES: <ul> <li> Designs and develops architecture of cloud-based data management systems. </li> <li> Proficiency and practical experience in implementing Centralized (Data Warehouse) and decentralized (Data Mesh) data architectures. </li> <li> Creates data models including data storage, access, and usage patterns for cloud environments. </li> <li> Defines data security policies, authentication, and authorization mechanisms for cloud-based platforms. </li> <li> Collaborates with cross-functional teams to architect highly scalable, highly available, and highly performant cloud data solutions. </li> <li> Evaluates and recommends new cloud products and services for efficient data storage and processing. </li> <li> Ensures compliance with data governance policies and best practices in the cloud. </li> <li> Implements data management and data governance processes for cloud data. </li> <li> Conducts thorough analysis and documentation of cloud data architecture strategies and designs. </li> <li> Establish regular overall system performance assessment processes and action plans. </li> <li> Provide direction for the design and development of the data layers including review of ETL requirements. </li> <li> Capable of leading team design sessions and facilitating decisions. </li> <li> Experience in Data Integration leveraging Snowflake, Informatica IICS, SQL, Mulesoft and Python code to solve complex use cases </li> <li> Excellent understanding and practical experience on Salesforce CRM </li> <li> Ensure timely delivery of solutions meeting requirements and expectations </li> </ul> QUALIFICATIONS: Minimum experience/skills: <ul> <li> 5+ years of experience in Cloud Data Architecture, data warehousing, data modeling, ETL, enterprise and business information system architectures, and system engineering </li> <li> Thorough knowledge and Implementation experience of data warehouse and Enterprise Data architecture principles. </li> <li> 3-5 years of experience architecting/developing Cloud-based (AWS) data solutions. </li> <li> 5+ years of Cloud database platform experience such as Snowflake. </li> <li> Experience in creating, reviewing and maintaining end-to-end data architectures. </li> <li> Strong communication skills comfortable explaining/proposing solutions to technical stakeholders, vendors, and business consumers. </li> </ul> <ul> <li> Proficiency with Unix, Linux, and shell scripting </li> <li> Experience working with a large, multi-terabyte enterprise data platform in Cloud. </li> <li> Experience with system administration, database administration, storage architectures, backup & recovery, and networking. </li> <li> Informatica (IICS) ETL and Mulesoft experience </li> <li> Salesforce Experience </li> <li> Experience working with highly sensitive health care information and familiar with HIP nd other data privacy controls. </li> </ul>Preferred experience/skills: <ul> <li> mazon Web Services (AWS) Certification or Cloud Data architect Certification </li> <li> Snowflake certification </li> <li> Tableau reporting experience </li> <li> Salesforce experience </li> </ul> EEO: "Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of - Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans."

Department Overview The Office of the CIO (OCIO) represents the cross-functional IT Management capabilities that enable running the business of IT. The OCIO focuses on supporting IT's operation model by ensuring a consistent, transparent, and efficient approach to the way the IT organization delivers value to its partners. The core of the OCIO consists of four areas essential to the long-term success of IT: Contract Management, Business Operations, Program Management Office, and Investment Management. Position Summary Client is seeking a highly motivated Senior Business Analyst to compile and analyze key metrics data to help leaders make informed business decisions. The analyst must have the ability to drive discussions with teams to assist with solving complex business problems. The successful candidate will work with multiple teams within the Information Technology Organization to develop and utilize financial and contracts metrics data for strategic business initiatives and operations. They will lead meetings, form teams, assign tasks, solve data driven problems and manage issues. The person will research best practices; develop internal and external benchmarks in support of helping leaders with business decisions. Additionally, they will have the ability to communicate and influence organizational change and gain organizational support. This role may require the analyst to perform quality assurance and business process improvement activities such as developing, managing, or coordinating performance or quality assessment, change management communications and training. Specific types of analytics and reporting may include performance dashboards, business analytics, modeling, budgeting, and forecasting. Job Responsibilities Budget Management: Develop, manage, and monitor the annual budget process, ensuring alignment with organizational goals and objectives. Collaborate with department lead planners to gather budget inputs and provide guidance. Forecasting: Lead the forecasting process, including monthly, quarterly, and annual forecasts. Analyze variances between actuals and forecasts and provide actionable insights to management. Financial Analysis: Conduct detailed financial analysis to support business decisions, including profitability analysis, cost-benefit analysis, and scenario planning. Cost Allocation: Design and maintain cost allocation models to accurately distribute costs across departments and projects. Ensure compliance with internal policies and external regulations. Reporting: Prepare and present financial reports and dashboards to senior management, highlighting key financial metrics, trends, and variances. Strategic Planning: Support long-term strategic planning initiatives by providing financial projections, risk assessments, and recommendations for improvement. Data Management: Maintain and improve financial databases and systems to ensure data accuracy and integrity. Implement process improvements to enhance efficiency and reporting capabilities. Collaboration: Work closely with cross-functional teams, including business finance, operations, and executive leadership, to provide financial insights and support business initiatives. Experience with downloading and extracting data from SAP and creating meaningful business intelligence reports and dashboards Create metrics and compile dashboards and reports; develop summary variance explanations and recommends remedial actions Assist with the daily operations and provide general IT business & planning support. Assist in the initiation and coordinating of studies and analysis on IT operations, resource allocation, financial reviews; and analyzing programs to ensure that program goals and work plans are on target. Analyzes actual spend and forecasting to determine if/when appropriate Change Controls must be implemented. Provides financial analysis on portfolio cost variances for plan vs. actual and can identify inappropriate charges by resources or vendors and makes appropriate corrections in SAP. Proficient in mapping data to original source systems to ensure data accuracy and consistency Perform data verification and validation (i.e. tracing, spot checks, building controls) to identify discrepancies and maintain data integrity May work as a liaison among stakeholders to coordinate, document, and schedule changes to IT infrastructure and information systems. Capture, analyze and present data to managers and directors to aid in making business decisions. Effectively plans and control work on a small project; integrates all aspects, tracks and ensures that work progresses on schedule and that work meets specification or required standard. Develops communications needed to summarize analysis and to discuss recommendations for peers and executives. This may take the form of dashboards or power point decks. Facilitates problems solving sessions and workshops with diverse set of business and technology team members. Proactively follows-up on issues and initiatives for senior leaders to ensure successful resolution and implementation. Works closely with leaders and other key stakeholders to ensure that key initiatives and activities are delivered in a timely and coordinated manner and aligned with the goals of the organization. Works with IT and functional leadership to establish a variety of key business, financial and performance metrics. Qualifications Minimum: Bachelors Degree in Business Administration or job-related discipline or equivalent experience 6 - 8 years job-related experience Expert with Power BI. Able to create dashboards from data sets Desired: MBA or Graduate Degree Proficient in Microsoft Office, Project, Visio, PowerPoint and expert level Excel skills Experience with Power Automate and Power Apps is a plus Other Desired Experience: Technical Skills: Proficiency in financial modeling, Excel, and financial software (e.g., SAP, Oracle, Hyperion). Experience with data visualization tools (e.g. Tableau) is a plus. Analytical Skills: Strong analytical and problem-solving skills, with the ability to interpret complex financial data and provide strategic insights. Communication: Excellent written and verbal communication skills, with the ability to present complex information clearly and concisely to various stakeholders. Attention to Detail: High level of accuracy and attention to detail in financial analysis and reporting. Interpersonal Skills: Strong interpersonal skills with the ability to collaborate effectively across departments and with senior management. Financial Reporting: Excel and PowerPoint skills to provide monthly reporting. EEO: "Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of - Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans."

Our Opportunity: CRM Data Automation is a department whose core accountability is to support the Corporate Risk Management (CRM) organization in the efficient use of data in reporting, analytics, and modeling. In support of this, our role provides administration and oversight of data warehouse resources for the organization and provides data engineering resources as developers of data engineering processes and as technical lead for other teams who practice data engineering. We are looking for a Data Engineer to fill a role as an individual contributor. The role will be responsible for some of the key activities that are critical to the development, maintenance, and documentation of an integrated data infrastructure for Corporate Risk Management. Activities will include development and documentation of ETL/ELT processes. The ability to learn and understand complex business processes as part of the requirement gathering process is also required. This role reports to the Director of Software Development and Engineering on the CRM Data Automation Team. What you'll do: Work will include development of console applications to provide ETL and reporting capabilities. This development work should be expected to integrate with data sources and systems both internal and external to client. Written and verbal communication skills are a must. Listening and comprehension skills will be needed as part of the project onboarding and requirements gathering processes. The ideal candidate will have experience operating both independently and as part of team working a software project, as well as experience prioritizing work. Additional Job Details: What you have: Bachelor's degree or equivalent work experience 3-5 years' demonstrable hands-on experience in a development role Design, development, testing, implementation, and documentation of business solutions Database development experience Data structure/architecture's role in helping to enforce data quality ETL and Reporting automation experience Code driven experience, not solely using automation/RPA tools o Integration with external data sources and APIs Business Analysis experience developing complex SQL queries for small to large sets of data and leading query optimization efforts Expertise in GCP, SQL Server, Oracle DB and related technologies C#, Python, R and related language experience A strong understanding of OOP principles Experience writing testable and configurable code for use in multiple environments (dev, qa, preprod, prod) Experience establishing productive relationships with internal business partners and information technology partners Strong communication and relationship skills, including experience working with all levels of management Knowledge and understanding of the brokerage/investment advisory industry and the regulatory requirements related to the business Time management, organization, and prioritization skills The ability to work under deadlines EEO: "Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of - Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans."

Position Summary: Title: Senior Data Engineer - Pentaho Duration: 6 Months - Long Term Location: Washington, DC 20005 Hybrid Onsite: 2/3 days per week from Day1 Candidate should be comfortable with picking up official laptop from Client place during the onboarding process once offered. Summary/Objective: The Senior Data Engineer will execute on implementing business intelligence solutions across all divisions of the organization . The individual in this role will guide the team in the design and implementation of each solution and will implement improvements of technical standards, development processes, governance, and technologies. Essential Duties And Responsibilities: <ul> <li>Serve as a technical lead in the development of business intelligence solutions. </li> <li>Coordinate with scrum masters / project managers on optimizing scheduling, work allocations, and story assignments. </li> <li>Manage reporting environment including data sources, connections, security, subscriptions and metadata. </li> <li>Assist in initiative towards data access control and integrity across the enterprise. </li> <li>Create data models and schema for reliable and highly performant data marts and data warehouse. </li> <li>Develops complex ETL (extract, transform and load) SQL scripts to gather data from various databases and systems to make data available for enterprise analytics and reporting. </li> <li>Evaluate, test and implement new or upgraded software. </li> <li>Troubleshoot reported problems pertaining to reports and the reporting database environment, working closely with other IT members, especially DBAs, Systems Analysts and Systems Engineers, identifying the cause and designing or developing an approach for resolution. </li> <li>Assess impact of changes and updates to source production systems, planning and implementing resulting changes to reports. </li> <li>Identify areas for improvement within the EDS organization related to architecture, design, performance optimization, development process, workflows, governance, tools/technologies. </li> <li>Conduct end user training on data solutions. </li> </ul> Core Competencies: Forward Thinking: The ability to anticipate the implications and consequences of situations and take appropriate action to be prepared for possible contingencies. Thinks Critically: The ability to approach ones work analytically by identifying issues/questions, gathering and evaluating data, and creating evidence-based recommendations or solutions. Embrace Innovation & Change: The ability to respond positively to change and demonstrate flexibility, and openness to new ways of thinking and doing things. Communicate Openly & Effectively: The ability to effectively communicate in multiple modes and in a way that fosters understanding and dialogue, as well as engages with others in a way that demonstrates emotional intelligence. Performance Focused: The ability to take ownership for ones own or ones employees performance, by setting clear goals and expectations, tracking progress against the goals, providing feedback, and addressing performance problems and issues promptly Apply Customer Lens: The ability to provide the best service to customers (internal and external) with the goal of exceeding their expectations while maintaining integrity. Develop Self & Others: The ability to identify, learn, and apply new skills or habits as needed to perform successfully on the job. Foster Collaboration: The ability to look beyond immediate teams, broaden peer networks, and finding ways to partner with internal and external stakeholders to achieve success. Education, Experience And Skills: <ul> <li>Bachelor Degree and/or relevant technical training with no preferred certification. </li> <li>Over 8-10 years of experience in the field of Information Technology with proficiency in ETL design/development and Data Warehouse implementation/development </li> <li>Experienced in Design, Development and Implementation of large - scale projects in Financial, Shipping and Retail industries using Data Warehousing ETL tools (Pentaho) </li> <li>Knowledge about Software Development Lifecycle (SDLC), Agile, CI/CD deployment </li> <li>Experience in Architecting and building Data Warehouse systems and Business Intelligence systems including ETL using Pentaho BI Suite (Pentaho Data Integration Designer / Kettle) </li> <li>Hands on experience on the whole ETL (Extract Transformation & Load) process </li> <li>Experience in creating ETL transformations and jobs using Pentaho Kettle Spoon designer and Pentaho Data Integration Designer and scheduling </li> <li>Used various steps in Pentaho transformations including Row Normalizer, Row Demoralizer, Database Lookup, Database Join, Calculator, Add Sequence, Add Constants and various types of inputs and outputs for various data sources including Tables, Access, Text File, Excel and CSV file </li> <li>Integrating Kettle (ETL) with Hadoop and other various NoSQL data and loaded unstructured data into Hadoop File System (HDFS) </li> <li>Experience in performing Data Masking/Protection using Pentaho Data Integration (Kettle) </li></ul><ul> <li>Strong development experience in writing PL/SQL Stored Procedures, Functions, packages and debugging the code </li> <li>Strong development experience working with Columnar DBs preferably Client Vertica </li> <li>Strong expertise in Developing and Debugging MSSQL or PostgreSQL SQL scripts, functions, stored </li> <li>procedures, views, complex SQL queries, cursors, and triggers </li> <li>Expertise in Performance tuning, Query optimization and exception handling </li> </ul>

Position Summary: We are seeking a Senior Business Analyst to lead business and system analysis of technical, often complex, and highly visible agency projects for the Executive Office of Energy and Environmental Affairs' IT Department (EEA-IT). The Senior Business Analyst (BA) will work very closely with program managers, division leaders, and other key stakeholders to document detailed business requirements. The BA will then conduct thorough gap analyses and break down those business requirements into stories and tasks. The BA will guide our product throughout the software development lifecycle, collaborating with Project Managers, Technical Leads and Agency Leads, to drive the requirements elicitation process and the execution of complex software development within targeted deadlines. The ideal candidate will have strong experience working as a conduit between the business and the development team to identify and document requirements. The ideal candidate must be able to conduct thorough business process analysis to understand workflows and systems and document business' current processes and systems. The BA will secure confirmation from business lead that documentation was accurately documented. The candidate should have very strong communication nd organizational skills, attention to detail and problem-solving skills . Furthermore, the candidate must possess a strong technical acumen with the ability to translate information and research into non-technical language as necessary to effectively communicate across teams. The candidate would also help with software quality assurance (QA) through different phases of software development, test, and production releases. The candidate should be able to work on multiple projects at the same time and handle multiple timelines. Candidate must demonstrate: proven track record to lead complex software engineering projects. The ability to lead requirements gathering sessions with business stakeholders. bility to document these requirements in MS Visio, JIRA, MS Excel, etc. Full comprehension of all business requirements, demonstrated by the ability to accurately communicate them back to business stakeholders and technical teams. Very strong written and verbal communication skills. calm and reassuring demeanor and well-developed negotiation skills . sense of ownership and self-motivation Primary Responsibilities Work with stakeholders to research, understand, and document business processes and requirements using common tools such as JIRA, Visio, SharePoint, and MS Office Suite. <ul> <li> nalyze and document current state vs future state using UML methodologies. </li> <li> Work with software solution architects to communicate business needs, understand solution capabilities and constraints, and assist in documenting/translating solution architect visions to business partners. </li> </ul> Independently lead nd document requirements-gathering sessions. <ul> <li> Using agile methodology, create and maintain business requirements documentation. </li> </ul> Create clear organized user stories. Document detailed system specifications. Collaborate with UI/UX designer to develop UI specifications. Contribute to business analysis process maturity and governance programs. Perform software QA through Development, Test and Production release phases. Create test cases during the development process. Help execute tests through all phases. Document test results for development team and stakeholders. Work with development teams to analyze bugs and errors found. Work with project managers to execute deliverables throughout all phases of software delivery. May need to coordinate with Network and Infrastructure teams. Perform other duties related to software delivery as needed, including training end users. Qualifications Experience: 4+ years of relevant experience working in technology as Business Analyst. BS/MS or a 4-year degree in a related field is preferred, although candidates with more than 10 years of BA experience may substitute experience for this requirement. <ul> <li> Business Analysis Skills: Deep understanding of business processes, requirements gathering, and documentation is essential. Senior Client should be skilled in conducting stakeholder interviews, facilitating workshops, and translating business needs into technical requirements. </li> </ul> Communication Skills: Strong verbal and written communication skills are necessary for effectively conveying complex technical concepts to non-technical stakeholders (and vice versa) and collaborating with cross-functional teams. Problem-solving Abilities: Senior Client should be adept at identifying and solving business problems using analytical thinking and critical reasoning. They should be able to propose innovative solutions that align with both business objectives and technical constraints. Business Process Improvement Skills: Proven skills in breaking down and optimizing complex business processes. Proven experience leading and documenting requirements-gathering sessions and developing user stories. Strong working knowledge of software development, Waterfall and Agile (Scrum, Kanban) methodologies. <ul> <li> Demonstrated ability to prepare User Stories, Process Flows, BRDs, FRDs, Use Cases and Data Mapping documents. </li> <li> Must be able to prepare acceptance test plans, test cases, and QA processes and work directly with end-users to ensure that application functionality meets requirements. </li> <li> Experience with Jira is preferred. Experience with Smartsheet is a plus. </li> </ul> <ul> <li> Certifications: While not mandatory, certifications such as Certified Business Analysis Professional (CBAP) or Professional Scrum Product Owner (PSPO) are a plus. </li> </ul> Desired Skills daptability and Learning Agility: The technology landscape is constantly evolving, so a willingness to learn new tools, methodologies, and industry trends is crucial for staying relevant and effective in the role. Effective negotiator with the ability to successfully balance business needs with IT time and resource constraints and arrive at mutually acceptable outcomes. Comfort working in a fluid environment where visions and requirements may change. <ul> <li> Must be able to work independently, or direct technical staff with a collaborative, hands-on approach. </li> </ul> bility to manage multiple tasks simultaneously. <ul> <li> customer-first approach when working with others. </li> <li> Some background in environmental issues, energy, or government preferred but not required. </li> </ul>

Mindlance Interview Questions

Mindlance Interview Guides

Mindlance Interview Questions

Mindlance Salaries by Position

Mindlance Opening Jobs