Power BI Developer

Composecure

322d

About The Position

This role is responsible for designing, developing, and maintaining reporting and data solutions. This role requires close collaboration with internal stakeholders to ensure the successful creation and maintenance of the company's reports, data pipelines, and data warehouse to meet business needs. This role also drives the strategic direction of the company's BI initiatives and fosters a collaborative environment amongst cross functional teams.

Requirements

• Minimum 3 years of relevant experience.
• Bachelor's degree in computer science, data analytics, machine learning, or equivalent relevant experience required.
• Experience with cloud-based Bi environments (e.g. Azure, AWS) required.
• Strong understanding of data modeling, data visualization concepts, and ETL processes (e.g. SSIS, Azure Synapse, Informatica, Snowflake) required.
• Experience with SQL for data manipulation and extraction required.
• Strong knowledge of DAX required.
• Familiarity with data warehouse concepts (e.g. Azure Blob Storage, Snowflake, Redshift) required.
• Experience with Power Pivot, SSRS, Azure Synapse, or other reporting tools required.
• Excellent analytical and problem-solving skills.
• Excellent record keeping and auditing skills.
• Excellent communication skills, both oral and written.
• Strong attention to detail and ability to self-check work.
• Excellent time management skills.
• Task oriented excellent organizational skills, ability to prioritize workload.
• Enthusiastic attitude, cooperative team player, adaptable to new or changing circumstances, professional demeanor, sensitive to client needs, self-motivated, creative and innovative.

Responsibilities

• Head the design, development, and deployment of Power Bi and SSRS reports and dashboards.
• Collaborate with business stakeholders to understand their data needs and translate them into technical requirements.
• Develop and maintain data models, ensuring data accuracy and consistency.
• Serve as the tenant admin for Power Bi and work with the internal security team to ensure data security and compliance with relevant regulatory requirements.
• Optimize Power Bi and data solutions for performance and scalability.
• Create and manage data warehousing solutions, including database designs.
• Develop and maintain ETL processes to ensure data is accurately and efficiently loaded into the data warehouse.
• Integrate data from various sources, ensuring data quality and consistency.
• Work with the database administrator to optimize the performance of the data warehouse.
• Conduct troubleshooting on data pipelines and warehouse systems and provide support.
• Maintain clear and concise technical specifications, data mappings, and solution designs for Power BI projects.
• Document all processes within the data warehouse for future reference and troubleshooting.
• Manage the development and maintenance of data definitions, lineage, and catalogs for each of the company's data models.
• Oversee and manage Power Bi projects, providing guidance and support to the Business Intelligence team to ensure successful project delivery and adherence to best practices.
• Build relationships with key stakeholders responsible for information and performance management to ensure reporting needs for departments are met.
• Records meeting notes in Confluence and all project updates in Jira.
• Implements and enforces data governance policies and procedures to ensure data quality, compliance, and security.
• Monitors report usage metrics and following up with end users.
• Handles all Help Desk tickets related to reporting.
• Performs general software and hardware installations as required.
• Handles related email and telephone correspondence in a timely and professional manner.
• Responds to inquiries for the purpose of resolving problems, providing information and/or referring to appropriate personnel.
• Will be required to perform other job functions, as assigned.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Professional, Scientific, and Technical Services
• Education Level: Bachelor's degree