Business Intelligence Developer ----- Hybrid ---- at Remote, Remote, USA |
Email: [email protected] |
From: Dev Soni, Tek Inspirations LLC [email protected] Reply to: [email protected] JOB TITLE: Business Intelligence Developer MOI: SKYPE DURATION: 6+ MONTHS MAJOR RESPONSI ITIES: % of time Core Functions 25% Oversee Data Analysis Solutions and Development: Manage data retrieval and analysis and organize data points according to the organizations needs. Design, develop and maintain business intelligence solutions. Craft and execute queries upon request for data. Present information through reports and visualization. Write complex queries to perform data analysis to ensure the accuracy and integrity of data. Identify problematic areas and conduct research to determine the best course of action to correct the data. Troubleshoot and research data anomalies and recommend corrective actions. Monitor for timely and accurate completion of data processes and scheduled jobs and troubleshoot, as necessary. 25% Develop and Create Process: Evaluate and improve existing BI systems. Design, build and deploy BI solutions (e.g. reporting tools). Maintain and support data analytics platforms. Create and maintain tools to store data. Conduct unit testing and troubleshooting. Collaborate with internal and external teams to integrate systems. Develop and execute database queries and conduct analyses. 25% Creating reports and testing: Develop graphs and reports, and presentations of project results. Perform basic statistical analyses for projects and reports. Create and present quality dashboards. Generate routine and ad-hoc reports. Provides timely and accurate progress information for project status reports. Utilize analytics to improve availability, reliability, efficiency, and capacity. 25% Effective Partnerships: Partner cross-organizationally to drive minimal costs on optimal solutions. Provide in-depth technical information to stakeholders as needed. Collaborate with internal Information Technology (IT) personnel and external IT Partners. QUALIFICATIONS: Must have 8 years plus related experience as BI Developer, SQL Developer, or similar position. Must have advanced and strong hands-on experience of BI technologies (e.g. SSRS, SSIS, Advanced SQL Development, Power BI, SQL Server Administration) Excellent problem-solving skills and soft skills to interface with report users directly to vet requirements and troubleshoot report inaccuracies. Bachelors or associate degree in information technology, Computer Science, Mathematics, Statistics, or related fields preferred or equivalent professional experience Experience with reporting from salesforce desired but not required. Experience performance tuning SQL server desired but not required. KEY COMPETENCIES: Ability to collect, gather and aggregate data from multiple sources and present in comprehensive reports Ability to demonstrate initiative, priority setting, problem solving and follow through. Experience with the T-SQL scripting/programming language, including the ability to develop, test, and debug ad-hoc queries, stored procedures, and data migration scripts. Experience with Microsoft Reporting and BI Tools (SSIS, SSRS, Power BI, etc.). Solid understanding of ETL strategies and design, (staging environments, data transformation, change data capture, slowly changing dimensions, etc.), with an eye towards delivering functional and useful solutions in a timely manner. Expert organizational and project management skills Knowledge of standard data modeling patterns and practices, e.g. Relational and Dimensional models. Strong analysis, coding, testing, documenting and implementation experience in both a development and maintenance environment. Exceptional interpersonal and communication skills with the ability to deal with a diverse range of people, which includes the upper levels of corporate management Proven abilities to take initiative and be innovative Analytical mind with a problem-solving aptitude Highly effective verbal and written skills with ability to effectively summarize data in laymens terms in reports and presentations Detail oriented, curious and always looking for new ways to engage our potential customers Keywords: business intelligence active directory information technology |
[email protected] View all |
Thu Dec 07 22:13:00 UTC 2023 |