Job Description
Job Title:Power BI/BI Engineer (C2H)
Location: Dallas, TX and Boston, MA (Remote)
Duration: 6 -12 months of Contract.
Only GC and USC are comfortable with C2H after 6 -12 months of Contract.
We are accepting profiles on C2C.
Job Description:
- Design, build, and deploy business intelligence solutions with Microsoft's BI stack and other BI tools.
- Perform ETL development utilizing SQL queries, stored procedures, functions, views, SSIS packages and other tools as necessary to meet all customer requirements.
- Plan, design, develop and implement robust ETL processes between internal systems and external systems.
- Develop integrations and support a large enterprise data warehouse integrated into several disparate database platforms.
- Build reporting solutions for diverse business functions utilizing various reporting tools such as Microsoft SSRS, Tableau and Power BI.
- Develop an in-depth understanding of our data environment and leverage knowledge to build robust, user-friendly reports and visualizations by utilizing diverse reporting tools.
- Primarily work within MS-SQL, but access Oracle, DB2 and other database platforms, as well as import/export to a variety of file formats.
- Job duties will include all phases of the SDLC process for database development, including problem definition, requirements gathering, design, build, test, implement and ongoing support.
- Follow design and development standards and guidelines as defined by the IT development team.
- Assist in the designing, planning, and implementation of disaster recovery policies and procedures.
- Work with business analysts and application development staff to develop and enforce database architectures, coding standards and quality assurance policies and procedures.
- Proactively contribute, offer recommendations, and identify risks and solutions associated with proposed or existing database solutions and strategies.
- Work cooperatively with business analysts to define business needs, translating those needs into system requirements and clearly defining the scope of the solution.
- Consult and coordinate with business analysts and other programmers to design and develop automated business systems.
- Understand the data elements, database structures, and data flows within an enterprise system.
- Assist with new software/hardware implementation including initial training, follow-up support, and ongoing continuous application improvement.
- Track and document changes to functional and business specifications.
- Create or assist others in writing user documentation, instructions, and procedures.
- Monitor and document post-implementation problems and revision requests.
Competencies, Skills and Abilities:
- Requires a Master's degree in Computer Science, Information Systems, Business Analytics, or a related field, plus 2 years of experience with SSRS reports developing Business Intelligence and Business Analytics reports.
- Additional requirements include: 2 years of experience working with business requirements for projects, including designing and building reports; 2 years of experience creating dashboard-style reports with Tableau; 2 years of experience with Server Integration Services (SSIS), or other ETL protocols; and 2 years of experience with Microsoft SQL.
- Or in the alternative, Employer accepts a Bachelor's degree in Computer Science, Information Systems, Business Analytics, or a related field, plus 5 years of experience with SSRS reports developing Business Intelligence and Business Analytics reports.
- 5 years of experience working with business requirements for projects, including designing and building reports; 5 years of experience creating dashboard-style reports with Tableau; 5 years of experience with Server Integration Services (SSIS), or other ETL protocols; and 5 years of experience with Microsoft SQL.