Power BI Data Engineer

About Client: Client is a company that helps other businesses use technology to improve and grow. They provide services like creating computer programs, managing computer systems, and making sure everything is secure. Client works with different industries like telecommunications, healthcare, banking, and retail to help them use new and exciting technologies like artificial intelligence, cloud computing, and the Internet of Things. These technologies can make businesses more efficient and innovative. They have offices and people working all around the world, and their team of experts helps businesses solve their technology challenges. Client also cares about making a positive impact on society and the environment, so they support social causes and work to conserve resources.

Rate Range: $60-$65/Hr

Job Description: Operations Monitoring and Rapid data solutions team, which is part of ITSFE is seeking a Data Modelling and Analytics Expert with specialized skills in Power BI Semantic Model development and DAX (Data Analysis Expressions) query implementation. The ideal candidate will also possess expertise in SQL Query, Databricks Lakehouse, Azure Databricks, and DBT to enhance our data analytics capabilities. Responsibilities:

The primary objective of this role is to design, implement and maintain a robust Semantic Model in Power BI, enabling users to create meaningful insights and analytics. The expert will also be responsible for developing complex DAX queries to support reporting needs while leveraging Databricks for data processing and transformation. The Power BI Expert will be responsible for the following tasks: Semantic Model Development:

Design, develop and maintain a scalable and efficient Semantic Model tailored to business requirements. Ensure the Semantic Model supports optimal performance and user experience. Collaborate with stakeholders to gather requirements and validate model design. DAX Query Implementation:

Write and optimize DAX queries to create calculated columns, measures, and tables as needed. Ensure DAX calculations are efficient and support the reporting framework. Provide guidance on best practices for DAX usage among team members. Databricks and Azure Databricks Integration:

Utilize Databricks Lakehouse to manage large volumes of data effectively. Implement data processing workflows using Azure Databricks, ensuring smooth integration with Power BI. Develop and maintain ETL pipelines using Databricks to prepare data for analysis. DBT (Data Build Tool) Implementation:

Implement DBT for data transformation and modeling within the data pipeline. Create modular and reusable DBT models that align with business requirements. Collaborate with data engineers to ensure data quality and integrity. Advanced Hands-On Experiences:

Utilize advanced Power BI features, including row-level security, incremental data refresh, and Power Query for data transformation. Implement custom visuals and integrate APIs to extend Power BI functionality. Develop advanced analytical solutions using AI capabilities within Power BI, such as predictive analytics and machine learning models. Leverage advanced data modeling techniques, including star schema design, to improve query performance and simplify data analysis. Reporting and Dashboard Creation:

Assist in developing interactive dashboards and reports based on the Semantic Model. Implement user-friendly features that enhance data accessibility and visualization. Performance Monitoring and Optimization:

Monitor the performance of the Semantic Model, DAX queries, and data pipelines. Implement strategies to optimize performance as data volumes grow. 4. Qualifications:

Proven experience with Power BI, including Semantic Model development and DAX. Expertise in SQL Query, Databricks Lakehouse, Azure Databricks, and DBT. Strong understanding of data warehousing concepts and ETL processes. Familiarity with data visualization best practices. Excellent analytical and problem-solving skills. Strong communication and interpersonal skills.

About ApTask: ApTask is a leading global provider of workforce solutions and talent acquisition services, dedicated to shaping the future of work. As an African American-owned and Veteran-certified company, ApTask offers a comprehensive suite of services, including staffing and recruitment solutions, managed services, IT consulting, and project management. With a focus on excellence, collaboration, and innovation, ApTask provides unparalleled opportunities for professional growth and development. As a member of the ApTask team, you will have the chance to connect businesses with top-tier professionals, optimize workforce performance, and drive success across diverse industries. Join us at ApTask and be part of our mission to empower organizations to thrive while fostering a diverse and inclusive work environment.

Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.

Candidate Data Collection Disclaimer: At ApTask, we prioritize safeguarding your privacy. As part of our recruitment process, certain Personally Identifiable Information (PII) may be requested by our clients for verification and application purposes. Rest assured, we strictly adhere to confidentiality standards and comply with all relevant data protection laws. Please note that we only collect the necessary information as specified by each client and do not request sensitive details during the initial stages of recruitment.

If you have any concerns or queries about your personal information, please feel free to contact our compliance team at businessexcellence@aptask.com.