BI Developer IV

Finance of America Companies Inc.•Conshohocken, PA

44d

About The Position

Responsible for modeling, transforming, and documenting data to provide meaningful datasets that allow the business to gain insight used in making informed, data-driven leadership decisions.

Requirements

Minimum 10 years of related data warehouse and analysis experience, preferably in a financial technology industry.
Experience with SQL (T-SQL preferred), dimensional data modeling (Kimball/Inmon/star/snowflake), extract, transfer, load (ETL) development (SSIS preferred), data mart, and data warehouses.
Minimum 5 years of experience with reporting tools (e.g. Tableau, SSRS, Power BI, etc.).
Proficient with code versioning tools such as TFS and GIT.
Experience with programming skills in languages such as Python, Java, or Scala, and experience with SQL.
Experience with cloud-based data platforms, such as AWS, Azure, or Google Cloud.
Strong mathematical acumen to analyze equations.
Analytical and problem-solving skills with a customer service orientation to draw data insights.
Meticulous and detail oriented, meeting high expectations for precision and accuracy.
Must be a problem solver, critical thinker, self-motivated and possess integrity and a strong work ethic.
Ability to work independently on concurrent tasks and adhere to deadlines.
Experience working in an Agile environment and easily adapt to changing priorities.
Strong interpersonal, oral, and written communication, and presentation skills to clearly communicate data insights to stakeholders and leadership.
Organizational, prioritization, and time management skills with attention to detail.
Requires proficiency in MS Office Suite, especially Excel.
High School Diploma

Nice To Haves

Coaching, mentorship, and training experience is preferred.
Degree in Computer Science or related field

Responsibilities

Designs, develops, and implements enterprise and departmental data models into clean, tested, and reusable datasets, empowering end users and stakeholders to answer critical business questions.
Transforms, cleans, and aggregates data in a meaningful way ensuring accuracy and timeliness.
Works closely with business partners to capture their requirements, translates business needs into technical reporting specifications, and obtains BRD sign offs from business partners.
Quickly resolves data discrepancies, explains data findings, and garner final approval of the source-to-target mappings.
Builds and optimizes queries and stored procedures in SQL Server databases.
Partners with the data engineers to ensure that the data is properly loaded into the data warehouse.
Coaches and mentors more junior BI Developers, provide technical leadership, and drive BI best practices and standard and adherence to internal policies and procedures.
Maintain a customer-first mentality in collaboration with stakeholders, leaders, and fellow developers.
Performs other duties as assigned.