Sales & Operations Planning - ETL / BI Report Developer
Posted on Indeed on Apr 18, 2021

Sales & Operations Planning - ETL / BI Report Developer

Virtual Req #638

Saturday, April 17, 2021

More than 48 million Americans have some form of hearing loss. ClearCaptions service and equipment removes communication obstacles through its commitment to making lives better and adhering to the belief that every word matter. As a Federal Communications Commission (FCC) certified telephone captioning provider, ClearCaptions follows the highest industry standards for privacy, security and professionalism on all of our captioning calls. ClearCaptions is dedicated to developing fast, easy and life-changing communications for hard-of-hearing individuals.
ETL / BI Report Developer
The ETL / BI Report Developer reports to the Director of Corporate Information & Billing in the Finance department and is responsible for (1) report, dashboard and data visualization development & maintenance; (2) program documentation and data governance support activities; and (3) ETL development / maintenance to support reporting processes. The position will assist in developing, maintaining, and supporting the business intelligence activities including ETL and reporting efforts to elevate the company’s analysts and other end users who need timely, correct, and impactful information.
This position will work from a home-based office and will require availability to support our Corporate Operations in Pacific Standard Time.
  • Partner with users across functions at various levels to understand their business process needs and design reporting to measure & drive results.
    • Develop reports and dashboards via Power BI.
    • Assist with report development and maintenance within SSRS.
    • Be a resource within the company / share knowledge for developing in Power BI.
  • Partner with developers, DBAs, business, and IT team members to identify critical data and integrate it with into our services.
    • Assist in building our data flow architecture in the cloud.
    • Develop ETL packages, maintain, and support them within SSIS.
    • Work with 3rd party data providers and APIs to pull data into Microsoft SQL Server.
    • Write, test, and troubleshoot complex T-SQL queries and stored procedures.
  • Ensure a high degree of data quality from end to end across integration.
    • Write and maintain documentation on reporting and integration processes.
    • Participate in the design and execution of governance activities associated with ensuring data solutions architecture assurance and compliance.
  • Minimum 3+ years of experience combination of:
    • MS Power BI dashboard, visualization & report development along with expertise in advanced data modeling and data shaping in Power BI (especially in conjunction w/ DAX, MDX and / or M). Working knowledge of MS Office (including Excel, Outlook, PowerPoint, Visio, & Word).
    • Report development and maintenance within SSRS.
    • T-SQL work (very strong knowledge of stored procedures, queries, joins, user-defined functions and ability to troubleshoot complex code).
    • Data Integration technologies and principles with a strong knowledge of SSIS, Azure Data Factory or similar with package development, deployment, and troubleshooting. (Including development of fault tolerant solutions).
    • Exceptional analytical skills and enjoys solving business problems.
    • Excellent written and verbal communication skills, with the ability to clearly explain technical issues to a technical and non-technical audience.
    • Ability to quickly understand reporting specification and make updates to reports/stored procedures.
    • Exceptionally detail orientated and consistently cross-checks data specifications.
    • Firm understanding of data warehousing fundamentals.
    • Proficient working independently—with little direction—and as a supportive team member.
    • Comfortable working with business partners across the organization.
    • Accustomed to fast-paced environments and multi-tasking with simultaneous, high-priority tasks.
Experience with the following a plus:
  • Power BI Premium deployment and usage.
  • Experience with Azure Platform, Data Factory, Data Bricks, Synapse, and/or Data Lakes.
  • Microsoft Power Automate tool construction, deployment and troubleshooting.
  • Experience with real-time data streaming or SOAP/REST data transmission technologies.
  • Working with JSON/XML/CSV formatted data.
  • Familiarity programming with C#/VB .NET programming language(s).
  • Understanding of regulated industries work such as telecommunications, finance, healthcare or related businesses.
  • Use of version control (GIT, SVN or other tools / methodologies).
  • Working in a Software Development Lifecycle (SDLC) environment and using related tools.
  • Understanding of optimization and data structures for scalability.
  • Utilization of SCRUM and Agile methodologies for iterative software development.
Physical Requirements:
Employees may experience the following physical demands for extended periods of time:
  • Sitting, standing and walking (95-100%)
  • Keyboarding (40-60%)
  • Viewing computer monitor, tablet and cell phone screen requiring close vision (40-60%)
Work Environment:
Work is performed in a remote office environment.
A competitive compensation package will be offered to successful candidates.

The above information on this description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications
required of employees to this job.

ClearCaptions is an equal opportunity, at will employer and does not discriminate against any employee or applicant for employment because of age, race, religion, color, disability, sex, sexual orientation or national origin.

Other details

  • Pay Type


Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Error on reporting

Related jobs

Bankers Healthcare Group
Kronos Incorporated
7 d ago
Percona Staffing

More jobs by this company