Business Intelligence and Data Analytics Developer - MJK Connections LLC

San Francisco, CA

About the Job

Our client is looking for a Business Intelligence and Data Analytics Developer will play a crucial role in leveraging data to drive informed business decisions. This position involves designing, developing and maintaining business intelligence solutions, as well as creating and implementing data analytics strategies. The successful candidate will collaborate with cross-functional teams to gather requirements, design data models and develop visualizations that empower stakeholders to make data-driven decisions.

Responsibilities

Design and develop data models that support business processes and reporting requirements.
Work with stakeholders to understand data needs and ensure the integrity and accuracy of data architecture.
Develop ETL processes to extract data from various sources, transform them into a usable format, and load it into data warehouses or other storage solutions.
Integrate data from diverse sources and systems to create a unified view for reporting and analysis.
Build and maintain dashboards, reports, MS SharePoint, and visualizations using Power BI to present insights to stakeholders.
Apply statistical analysis and data mining techniques to identify trends, patterns and correlations in data sets.
Develop predictive models to support forecasting and decision-making processes.
Collaborate with business analysts, data scientists, and other stakeholders to understand business requirements and translate them into technical solutions.
Implement data quality and governance standards to ensure the accuracy and reliability of data used for reporting and analytics.
Optimize queries, processes, and data models for improved performance and efficiency.
Document data models, ETL processes, and business intelligence solutions to ensure knowledge transfer and maintainability.
Provide training and support to end-users on business intelligence tools and data analytics platforms.
Maintain up-to-date documentation for configurations, procedures and troubleshooting guides.
Perform other duties commensurate to this position.

Who Are You?

Bachelors degree in Computer Science, Information Technology or a related field.
Must have a working knowledge of .Net (C# and VB), ASP.NET Web Services/Web APIs and SQL Server.
Banking industry experience with core banking system and data processing knowledge.
Proven experience in business intelligence, data analytics and ETL development.
Proficiency in SQL, database management and data warehousing concepts.
Experience with business intelligence tools such as Tableau, Power BI or similar.
Strong programming skills (e.g., Python, R) for data manipulation and analysis.
Knowledge of statistical analysis and machine learning concepts.
Knowledge of data governance and security best practices.
Must be highly skilled at writing SQL queries.
Must be self-motivated with exceptional time management, organization skills and attention to detail.
Must have well developed analytical and problem-solving skills to resolve problems as they occur and escalate as needed. Familiarity with Corelation (Keystone) banking Core is a plus.
Must possess excellent interpersonal relationship skills, ability to motivate and direct work through the efforts of others, discuss problems and solutions with all levels of staff and management and be approachable to the team.
Must have exceptional written and verbal communication.
Must be be authorized to work in the United States.

Why Join?

The compensation package includes an excellent benefits program including medical, dental, vision and life insurance plans, generous PTO, 40l(k) matching contributions, profit sharing, a competitive base compensation, bi-annual incentives as well as tuition reimbursement.

Source : MJK Connections LLC

Responsibilities

Design and develop data models that support business processes and reporting requirements.

Work with stakeholders to understand data needs and ensure the integrity and accuracy of data architecture.

Develop ETL processes to extract data from various sources, transform them into a usable format, and load it into data warehouses or other storage solutions.

Integrate data from diverse sources and systems to create a unified view for reporting and analysis.

Build and maintain dashboards, reports, MS SharePoint, and visualizations using Power BI to present insights to stakeholders.

Apply statistical analysis and data mining techniques to identify trends, patterns and correlations in data sets.

Develop predictive models to support forecasting and decision-making processes.

Collaborate with business analysts, data scientists, and other stakeholders to understand business requirements and translate them into technical solutions.

Implement data quality and governance standards to ensure the accuracy and reliability of data used for reporting and analytics.

Optimize queries, processes, and data models for improved performance and efficiency.

Document data models, ETL processes, and business intelligence solutions to ensure knowledge transfer and maintainability.

Provide training and support to end-users on business intelligence tools and data analytics platforms.

Maintain up-to-date documentation for configurations, procedures and troubleshooting guides.

Perform other duties commensurate to this position.

Who Are You?

Bachelors degree in Computer Science, Information Technology or a related field.

Must have a working knowledge of .Net (C# and VB), ASP.NET Web Services/Web APIs and SQL Server.

Banking industry experience with core banking system and data processing knowledge.

Proven experience in business intelligence, data analytics and ETL development.

Proficiency in SQL, database management and data warehousing concepts.

Experience with business intelligence tools such as Tableau, Power BI or similar.

Strong programming skills (e.g., Python, R) for data manipulation and analysis.

Knowledge of statistical analysis and machine learning concepts.

Knowledge of data governance and security best practices.

Must be highly skilled at writing SQL queries.

Must be self-motivated with exceptional time management, organization skills and attention to detail.

Must have well developed analytical and problem-solving skills to resolve problems as they occur and escalate as needed. Familiarity with Corelation (Keystone) banking Core is a plus.

Must possess excellent interpersonal relationship skills, ability to motivate and direct work through the efforts of others, discuss problems and solutions with all levels of staff and management and be approachable to the team.

Must have exceptional written and verbal communication.

Must be be authorized to work in the United States.

Why Join?

The compensation package includes an excellent benefits program including medical, dental, vision and life insurance plans, generous PTO, 40l(k) matching contributions, profit sharing, a competitive base compensation, bi-annual incentives as well as tuition reimbursement.