CompoSecure is looking to design, develop, and maintain reporting and data solutions to meet business needs, drive strategic direction of BI initiatives, and ensure data accuracy, consistency, security, and compliance.
Requirements
- 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.
Responsibilities
- Head the design, development, and deployment of Power Bi and SSRS reports and dashboards.
- 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.
Other
- Minimum 3 years of relevant experience.
- Collaborate with business stakeholders to understand their data needs and translate them into technical requirements.
- 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.
- 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.
