Short description
The Analytics Engineer works in the IT data team to build clean data sets & solutions for the business using technologies available within Microsoft Fabric. In this role, the Analytics Engineer reports to the Business Intelligence Manager & actively collaborates with business stakeholders, BI analysts, & others to design, implement, & maintain data systems and solutions.
Function description
Principal Duties and Responsibilities
- Data Engineering: Build, maintain, & optimize ETL data pipelines
- Data Modeling: Build, maintain, & optimize corporate semantic models
- Data Governance & Administration: Address IT tickets & troubleshoot system performance, Perform administrative duties to maintain the current data environment
- Analyst: Assist, as needed, with the development of reports and other solutions
- Communication: Work with stakeholders throughout solution lifecycle
- Stewardship: Improve platform stability, data value & quality, and promote a data culture, Actively collaborate with teammates to share workloads, develop skills, & strengthen the team
Skills & Experience
- Excellent leadership & interpersonal skills
- Excellent verbal & written communication skills
- Comfortable operating in a past-paced, dynamic, customer-facing role
- Comfortable prioritizing & ability to manage work & stakeholders across multiple projects
- Work within an enterprise data environment- version control, change & integration management, etc.
- Strong ability to take ownership of work
- Strong ability to learn, develop & apply business processes
- Strong ability to manage ambiguity & solve undefined problems
- Strong skills in data engineering with a willingness to support on the visualization layer
- Strong skills in troubleshooting concepts
- Strong skills in Python, SQL, M, DAX
- Experience with SQL Server Management Studio, DAX Studio, Tabular Editor, & ALM Toolkit a plus
- Eager to contribute in a team-oriented environment
Requirements
Qualifications / Education
- 2+ years sustaining an enterprise data architecture, such as a common data model or data warehouse
- 2+ years working with internal stakeholders
- 2+ years of owning full lifecycle of BI projects/solutions
- 3-5 years of hands-on enterprise data engineering/ETL experience
- 3-5 years of hands-on enterprise data modeling experience
- 3-5 years of hands-on experience with Microsoft Business Intelligence stack
- Bachelor’s degree in computer science, data science, engineering, or comparable field
- Microsoft Fabric Analytics Engineer Certification a strong plus
Physical requirements:
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. While performing the duties of this Job, the employee is regularly required to sit, walk and stand; talk or hear, both in person and by telephone; use hands repetitively to finger, handle, feel or operate standard office equipment. The employee is frequently required to reach with hands and arms. The employee is occasionally required to stand; walk and stoop, kneel, crouch, or crawl. The employee must frequently lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision and the ability to adjust focus.
iPS Powerful People is a technical manpower provider with extensive experience supporting the successful execution and operation of major capital project investments. Forged through a desire to provide best-in-class service to clients, candidates, and contractors alike, iPS Powerful People works through its offices nationwide to provide regional support to a wide range of sectors including both traditional energy and energy transition initiatives (e.g., LNG, hydrogen, wind, solar), as well as manufacturing, mining, and infrastructure.
