Urgent need for Lead SQL Developer - Charlotte, NC (hybrid onsite 3x a week)

Lead SQL Developer

Charlotte, NC (hybrid onsite 3x a week)

1 year contract

Description:

• The SQL Developer is responsible for developing and troubleshooting queries and building reporting that provides financial information to stakeholders
• This role is within the Finance department and reports to the Manager of Financial Business Intelligence
• Key responsibilities include writing SQL queries to extract data from Big Query to leverage for Power BI dashboards, building and maintaining reports in Power BI, and supporting financial systems and Finance via data and report development
• Core competencies include a solid knowledge of SQL development and debugging, IT database structures, Power BI, QA testing, as well as excellent communication and collaboration skills

Impact:

• The SQL Developer is responsible for understanding business needs and problems, and partnering with stakeholders to provide reporting that can drive more informed decision-making
• Core responsibilities include leveraging SQL and Big Query to source and structure data for reporting, compiling user requirements, building reports in Power BI, and maintaining documentation on dashboards
• Writing complex SQL queries based on business and reporting needs
• Troubleshooting and resolving data related issues
• Working with cross functional teams to gather requirements and prioritize enhancement and development requests
• Analyzing data from multiple sources and working through nuances while maintaining data integrity
• Creating and maintaining documentation for queries, data, and requirements
• Optimize queries and document schema
• Working with IT to support and test data and report migrations
• The BI Developer is responsible for ensuring that data is accurate, ties to reported results, and that any issues are escalated to appropriate stakeholders
• Additional responsibilities in support of financial systems are required for various projects such as data warehouse migrations, QA testing, and data integrity assurance initiatives
• The above statements are intended to describe the general nature and level of work being performed and are not intended to be an exhaustive list of all responsibilities, duties and skills required

You will thrive in this role if you:

• 5 years of progressive experience in SQL, including designing, developing, and troubleshooting complex queries
• Familiar using BigQuery to retrieve data
• Experience with major data migrations involving both business and IT stakeholders
• Solid understanding of database design principles and experience with data modeling, in addition to query planning & optimization
• Proven ability to work with cross functional teams to prioritize and achieve results
• Attention to detail that translates into strong analytical results and problem-solving
• Ability to take initiative and work effectively in a fast-paced environment
• Excellent communication and collaboration skills

A plus if you have:

• Experience with SAP or Alteryx
• Experience working on product profitability models
• Experience with securitization