Job Description
Client: Fintech
Location: Somerset, NJ
Type: Direct hire
Position Overview:
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, in order 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.
Key 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 to ensure 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.
ETL & Data Warehousing
- 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 to ensure data quality and consistency.
- Work with the database administrator to optimize the data warehouse's performance.
- Conduct troubleshooting on data pipelines and warehouse systems and provide support.
Training & Documentation
- 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.
Project Management
- 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 that departmental reporting needs are met.
- Record meeting notes in Confluence and all project updates in Jira.
Data Governance
- Implements and enforces data governance policies and procedures to ensure data quality, compliance, and security.
- Monitors report usage metrics and follow up with end users.
Routine IT Functions
- Handles all Help Desk tickets related to reporting.
- Performs general software and hardware installations as required.
Other Important Responsibilities
- Handles related email and telephone correspondence in a timely and professional manner.
- Responds to inquiries to resolve problems, providing information and/or referring to appropriate personnel.
- Will be required to perform other job functions, as assigned.
Qualifications:
- 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 is required.
- Strong knowledge of DAX required.
- Familiarity with data warehouse concepts (e.g., Azure Blob Storage, Snowflake, Redshift) is 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, and 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.
Job Tags