Data (Power Bi) Engineer

E2 Consulting Engineers, Inc. (E2) is a professional services firm established in 1988 specializing in a full spectrum of engineering services including, project engineering and design, federal base operations and infrastructure support services, gas pipeline construction and inspection services, environmental consulting and remediation, and information technology services. At E2, we value safety, innovation and collaboration, and we are dedicated to excellence.

E2 is seeking a highly motivated Data (PowerBI) Engineer to join our team and partner with our client to design, develop, and implement highly functional and scalable PowerBI data analytics solutions. The successful candidate will thrive on delivering production-quality dashboards, process and workflow automation, automated reporting solutions, and complex calculations and measures. The right person for this role has a strong background in data engineering/data visualization/data warehousing, loves problem-solving, and is a great communicator. This role is remote with travel to California every month to the client location.

• Design, develop, and implement Power BI dashboards and reports to meet business requirements.
• Work closely with stakeholders to gather and understand reporting requirements.
• Utilize DAX (Data Analysis Expressions) to create complex calculations and measures.
• Develop and maintain Power Automate flows to automate data workflows and processes.
• Integrate Power BI with Power Automate and other external data sources for seamless data updates and synchronization.
• Utilize Rest API for data extraction and integration into Power BI.
• Write and optimize SQL queries to retrieve and manipulate data from various databases.
• Implement and maintain data security measures within Power BI, ensuring compliance with organizational policies.
• Develop role-based access control and manage user access to reports and dashboards.

Education

• Bachelors degree in Computer Science, Information Technology or related field.

Experience

• 5+ Years in Data analysis, business intelligence or related fields (required).

Power BI Experience and Skills Required

• Experience with Power Automate, SharePoint it strongly preferred.
• Data Modeling and Transformation.
• Apply advanced data visualization techniques.
• Data integration with External sources.
• Implement version control for Power BI artifacts to track changes and facilitate collaboration.
• Advanced understanding of data warehousing concepts, including star and snowflake schemas.
• Proficiency in optimizing data models for large datasets and complex relationships.
• Ability to troubleshoot and resolve issues related to data refresh, connectivity, and performance.
• Conduct training sessions for end-users on Power BI functionality and best practices.
• In-depth knowledge of Power BI features such as row-level security, custom connectors, and Power Query M language.
• Experience with Power BI Premium.
• Capability to design and implement complex data transformations using Power Query Editor.
• Strong proficiency in SQL queries, SQL Agent, and Store procedures.
• Knowledge of Rest API.
• Understanding of data security principles and best practices.
• Excellent communication and collaboration skills.
• Certification in Power BI is a plus.

E2 Consulting Engineers, Inc. offers an excellent benefits package including health, dental, vision, and life insurance, 401(k) with employer match, paid time off.

Salary range for this position is $85,000 - $115,000.  The starting salary will be commensurate with skill, education, experience, and working environment.

Work Environment

This job operates in a professional office environment and uses standard office equipment such as computers and phones.

Physical Demands

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. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Ability to sit/stand for up to 8 hours per day.
• Ability to move freely for up to 8 hours per day.

Travel to California every month to the client location.

E2 Consulting Engineers, Inc. is a Drug Free Workplace. After accepting an offer of employment, applicants may be required to undergo background checks, drug testing, and/or fit-for-duty physical examination.  Drug screens will include, but not be limited to, Amphetamines, Cocaine Metabolites, Marijuana Metabolites (THC), Opiates, and Phencyclidine (PCP). As a federal contractor, E2 cannot permit employees in certain positions to use medical marijuana, even if prescribed by an authorized physician.

Please no solicitation of any kind from agencies, staffing, or recruiting firms.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.