Job description

Job title: Senior Business Intelligence Developer

Job type: Full-time/Permanent

Location: Washington, D.C

Responsibilities

• Analyze data structures under current data hubs (FXO, Freshsales), make recommendations, and propose a model to optimize queries and processes for corporate dashboards.
• Develop technical infrastructure designs, data mappings, flows, and report dissemination mechanisms for data.
• Analyze source corporate data of different types and design/improve programs for extraction, transformation, and loading into a centralized database.
• Work with other teams to map data elements for ETLs, e.g., uploading sales leads to our CRM.
• Create data dictionaries and maintain metadata.
• Apply ad hoc data extraction tools to applications and systems’ data extraction and migration.
• Create and manage SQL database objects including tables, indexes, and procedures.
• Support the follow-up process of the corporate CRM (Freshsales), providing analytical support as needed and coordinating improvements to current processes and services; including the automation of the Lead Scrubbing process for Sales Operations.
• Design, develop and test programs using SQL Server, PowerBI, and Integromat for database applications and automation.
• Develop and generate standard and ad hoc reporting capabilities from new and existing data sources, and pinpoint data inaccuracies for further Sales Operations investigation.
• Develop and modify queries, programs, and stored procedures to support standard and ad hoc reporting.
• Support efforts to increase operational efficiency through innovation, process improvement, and the use of analytics to be used in digital transformation initiatives.
• Support in the establishment of streamlined quality control processes to ensure accuracy, completeness, and consistency of data in operational and corporate systems.
• As a strategic partner to our internal units, act as an advisor to apply data and digital intelligence for decision-making, operations design, and strategic communications.
• Be proactive and find new data engines to import high-quality leads and prospects.
• Provide inputs, document requirements, and support the design and delivery of each requirement of other user units.
• Provide mentoring and assistance to new IT staff and create support materials.

Required Qualifications

• Master's Degree (or comparable work experience) in computer science, information technology, systems engineering, with emphasis in data analytics and data management.
• A minimum of 3-5 years of relevant experience related to the key responsibilities of the position, ideally in the context of financial institutions.
• Ability to tell stories with data
• Strong analytical and reporting skills
• Experience with a CRM
• Power BI (or comparable tool) for data manipulation and visualization
• High proficiency in MSOffice 365
• Advanced MS Excel and Access (including macros and VBA coding/scripts)
• Experience with Scripts/Views in SQL Server
• Experience with ETL Tools
• Experience with Workflow automation tools, such as Zapier or Integromat
• Ability to learn new software and skills with limited assistance
• Capability to manage large datasets from multiple sources/technology
• Ability to track multiple projects and anticipate issues
• Capability to provide analysis and maintain clear and comprehensive documentation of data preparation and processes
• Collaborative team player with solid verbal and written communication skills and the ability to coordinate with IT personnel and business units.
• Agile approach to understand client needs and provide services that meet expectations of quality and timeliness

Preferred Qualifications

• Studies/certificates in Finance or Business is a plus.
• Freshsales Experience
• Salesforce Experience
• Experience in financial institutions
• Experience with financial modeling
• Python experience

Job Type: Full-time

Salary: $100,000.00 - $120,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Employee discount
• Flexible schedule
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Referral program
• Relocation assistance
• Retirement plan
• Tuition reimbursement
• Vision insurance

Compensation package:

• Bonus pay
• Performance bonus
• Yearly pay

Experience level:

• 3 years

Schedule:

• 8 hour shift
• Day shift

Application Question(s):

• What is your Visa type?
• What' your full-time salary expectation?

Experience:

• Power BI: 4 years (Required)

Work Location: On the road

Speak with the employer
+91 6092376952

blackflymedia.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, blackflymedia.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, blackflymedia.com is the ideal place to find your next job.