What are the responsibilities and job description for the Power BI Developer position at CompoSecure?
About CompoSecure
Founded in 2000, CompoSecure (Nasdaq: CMPO) is a technology partner to market leaders, fintechs and consumers enabling trust for millions of people around the globe. The company combines elegance, simplicity, and security to deliver exceptional experiences and peace of mind in the physical and digital world. CompoSecure's innovative payment card technology and metal cards with Arculus security and authentication capabilities deliver unique, premium branded experiences, enable people to access and use their financial and digital assets, and ensure trust at the point of a transaction. For more information, please visit www.CompoSecure.com and www.GetArculus.com.
Position Summary
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.
Essential Responsibilities
CompoSecure is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, or national origin. We are also an equal opportunity employer of individuals with disabilities and protected veterans.
Founded in 2000, CompoSecure (Nasdaq: CMPO) is a technology partner to market leaders, fintechs and consumers enabling trust for millions of people around the globe. The company combines elegance, simplicity, and security to deliver exceptional experiences and peace of mind in the physical and digital world. CompoSecure's innovative payment card technology and metal cards with Arculus security and authentication capabilities deliver unique, premium branded experiences, enable people to access and use their financial and digital assets, and ensure trust at the point of a transaction. For more information, please visit www.CompoSecure.com and www.GetArculus.com.
Position Summary
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.
Essential Responsibilities
- Power Bi Reporting & Administration
- 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.
- 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.
CompoSecure is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, or national origin. We are also an equal opportunity employer of individuals with disabilities and protected veterans.